package com.yonyou.iuap.jxzy.servlet.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.yonyou.iuap.jxzy.entity.PoundBillVO;
import com.yonyou.iuap.jxzy.entity.PoundderLiver;
import com.yonyou.iuap.jxzy.servlet.DeviceInfo;
import com.yonyou.iuap.mybatis.anotation.MyBatisRepository;

@MyBatisRepository
public interface DeviceMapper {
	
	public List<DeviceInfo> queryDeviceInfo();
	
	public String queryPoundByCardno(@Param(value = "cardno")String cardno);
	
	/**更具刷卡机编码获取他所对应控制的摄像设备*/
	public List<String> queryVideoByDevid(@Param(value = "devid")String devid);
	
	public String queryCardnoByCardid(@Param(value = "cardid")String cardid);
	
	/**根据刷卡设备编码获取led*/
	public String getDivicecode(@Param(value="deviceCode")String deviceCode);
	
	/**根据刷卡设备编码获取多个led*/
	public List<DeviceInfo> getDivicecodelist(@Param(value="deviceCode")String deviceCode);

	/**获取led显示 加抽位置*/
	public String getLedText(@Param(value="pk_pound")String pk_pound);
	/**获取led显示 抽样位置*/
	public String getSampleLoaction(@Param(value="pk_pound")String pk_pound);

	/**车牌号获取*/
	public String getLicenselPlateNo(@Param(value="pk_pound")String pk_pound);

	/**审核状态 获取*/
	public String getAuditStatus(@Param(value="pk_pound")String pk_pound);

	/**获取磅单表*/
	public PoundBillVO getPounderLiver(@Param(value="pk_pound")String pk_pound);
	
	/**根据卡ID获取车牌号*/
	public String queryVehicleByCardid(@Param(value = "cardid")String cardid);
	
	/**根据卡号获取未完成磅单车牌号及总包数*/
	public List<PoundBillVO> queryPoundVde3ByCardno(@Param(value = "cardno")String cardno);

	/**更新抽样区到磅单表*/
	public int updateAreaToPound(@Param(value = "pk_pound")String pk_pound, @Param(value = "samparea")String samparea);
	
	/**根据抽样区获取led设备明细*/
	public List<DeviceInfo> queryLEDDeviceVO(String samplingarea);
	
	/**查询抽样监控区刷卡时间*/
	public String getsksj(@Param(value="pk_pound")String pk_pound);
	/**更新抽样监控刷卡时间*/
	public int updatesksj(@Param(value = "pk_pound")String pk_pound, @Param(value = "devicecode")String devicecode,@Param(value = "sksj")String sksj,@Param(value = "vvchile")String vvchile);
	
	/**记录刷卡器异常日志*/
	public int InsertReadCardLog(@Param(value = "log")String log,@Param(value = "devicecode")String devicecode);
}
